MIC data report

Dataset statistics

Number of variables	15
Number of observations	2291
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	419.9 KiB
Average record size in memory	187.7 B

Variable types

Categorical	2
Numeric	13

Warnings

`Name` has a high cardinality: 2291 distinct values	High cardinality
`Meropenem` is highly correlated with `Piperacillin-tazobactam` and 5 other fields	High correlation
`Piperacillin-tazobactam` is highly correlated with `Meropenem` and 6 other fields	High correlation
`Aztreonam` is highly correlated with `Ceftriaxone` and 3 other fields	High correlation
`Ceftriaxone` is highly correlated with `Aztreonam` and 3 other fields	High correlation
`Ceftaroline` is highly correlated with `Aztreonam` and 3 other fields	High correlation
`Cefepime` is highly correlated with `Aztreonam` and 3 other fields	High correlation
`Ampicillin-sulbactam` is highly correlated with `Piperacillin-tazobactam`	High correlation
`Ceftazidime-avibactam` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Ceftobiprole` is highly correlated with `Ceftolozane-tazobactam`	High correlation
`Imipenem` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Ceftolozane-tazobactam` is highly correlated with `Meropenem` and 6 other fields	High correlation
`Doripenem` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Ceftazidime` is highly correlated with `Aztreonam` and 3 other fields	High correlation
`MeroRPX7009_fixed8` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Meropenem` is highly correlated with `Piperacillin-tazobactam` and 5 other fields	High correlation
`Piperacillin-tazobactam` is highly correlated with `Meropenem` and 6 other fields	High correlation
`Aztreonam` is highly correlated with `Ceftriaxone` and 2 other fields	High correlation
`Ceftriaxone` is highly correlated with `Aztreonam` and 4 other fields	High correlation
`Ceftaroline` is highly correlated with `Ceftriaxone`	High correlation
`Cefepime` is highly correlated with `Aztreonam` and 1 other fields	High correlation
`Ampicillin-sulbactam` is highly correlated with `Piperacillin-tazobactam`	High correlation
`Ceftazidime-avibactam` is highly correlated with `Meropenem` and 6 other fields	High correlation
`Ceftobiprole` is highly correlated with `Ceftriaxone` and 1 other fields	High correlation
`Imipenem` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Ceftolozane-tazobactam` is highly correlated with `Meropenem` and 7 other fields	High correlation
`Doripenem` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Ceftazidime` is highly correlated with `Aztreonam` and 3 other fields	High correlation
`MeroRPX7009_fixed8` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Meropenem` is highly correlated with `Piperacillin-tazobactam` and 5 other fields	High correlation
`Piperacillin-tazobactam` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Aztreonam` is highly correlated with `Ceftriaxone` and 2 other fields	High correlation
`Ceftriaxone` is highly correlated with `Aztreonam` and 3 other fields	High correlation
`Ceftaroline` is highly correlated with `Ceftriaxone`	High correlation
`Cefepime` is highly correlated with `Aztreonam`	High correlation
`Ampicillin-sulbactam` is highly correlated with `Piperacillin-tazobactam`	High correlation
`Ceftazidime-avibactam` is highly correlated with `Meropenem` and 4 other fields	High correlation
`Ceftobiprole` is highly correlated with `Ceftriaxone`	High correlation
`Imipenem` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Ceftolozane-tazobactam` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Doripenem` is highly correlated with `Meropenem` and 5 other fields	High correlation
`Ceftazidime` is highly correlated with `Aztreonam` and 1 other fields	High correlation
`MeroRPX7009_fixed8` is highly correlated with `Meropenem` and 3 other fields	High correlation
`Imipenem` is highly correlated with `MeroRPX7009_fixed8` and 4 other fields	High correlation
`Ceftaroline` is highly correlated with `Cefepime` and 5 other fields	High correlation
`Cefepime` is highly correlated with `Ceftaroline` and 5 other fields	High correlation
`Ceftazidime` is highly correlated with `Ceftaroline` and 7 other fields	High correlation
`MeroRPX7009_fixed8` is highly correlated with `Imipenem` and 5 other fields	High correlation
`Aztreonam` is highly correlated with `Ceftaroline` and 5 other fields	High correlation
`Doripenem` is highly correlated with `Imipenem` and 5 other fields	High correlation
`Ceftazidime-avibactam` is highly correlated with `Ceftazidime` and 5 other fields	High correlation
`Ceftolozane-tazobactam` is highly correlated with `Imipenem` and 8 other fields	High correlation
`Meropenem` is highly correlated with `Imipenem` and 5 other fields	High correlation
`Ceftobiprole` is highly correlated with `Ceftaroline` and 7 other fields	High correlation
`Ceftriaxone` is highly correlated with `Ceftaroline` and 4 other fields	High correlation
`Piperacillin-tazobactam` is highly correlated with `Imipenem` and 5 other fields	High correlation
`Ampicillin-sulbactam` is highly correlated with `Ceftaroline` and 6 other fields	High correlation
`Name` is uniformly distributed	Uniform
`Name` has unique values	Unique
`Ceftobiprole` has 173 (7.6%) zeros	Zeros
`Ceftolozane-tazobactam` has 174 (7.6%) zeros	Zeros
`MeroRPX7009_fixed8` has 176 (7.7%) zeros	Zeros

Reproduction

Analysis started	2021-06-07 23:41:32.686440
Analysis finished	2021-06-07 23:42:09.328057
Duration	36.64 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

Name
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	2291
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	169.4 KiB

Sentry-2017-1002212	1
Sentry-2017-1024266	1
Sentry-2016-981689	1
Sentry-2017-1013040	1
Sentry-2018-1077612	1
Other values (2286)	2286

Length

Max length	19
Median length	19
Mean length	18.6416412
Min length	18

Characters and Unicode

Total characters	42708
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2291 ?
Unique (%)	100.0%

Sample

1st row	Sentry-2016-933582
2nd row	Sentry-2016-934664
3rd row	Sentry-2016-934829
4th row	Sentry-2016-934925
5th row	Sentry-2016-934954

Common Values

Value	Count	Frequency (%)
Sentry-2017-1002212	1	< 0.1%
Sentry-2017-1024266	1	< 0.1%
Sentry-2016-981689	1	< 0.1%
Sentry-2017-1013040	1	< 0.1%
Sentry-2018-1077612	1	< 0.1%
Sentry-2016-980367	1	< 0.1%
Sentry-2016-968284	1	< 0.1%
Sentry-2017-1014111	1	< 0.1%
Sentry-2016-940361	1	< 0.1%
Sentry-2018-1044423	1	< 0.1%
Other values (2281)	2281	99.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sentry-2016-969224	1	< 0.1%
sentry-2018-1080175	1	< 0.1%
sentry-2017-1014846	1	< 0.1%
sentry-2018-1070995	1	< 0.1%
sentry-2018-1060799	1	< 0.1%
sentry-2017-1035072	1	< 0.1%
sentry-2018-1084153	1	< 0.1%
sentry-2017-1018780	1	< 0.1%
sentry-2017-1001230	1	< 0.1%
sentry-2018-1078386	1	< 0.1%
Other values (2281)	2281	99.6%

Most occurring characters

Value	Count	Frequency (%)
1	4851	11.4%
0	4752	11.1%
-	4582	10.7%
2	3428	8.0%
S	2291	5.4%
e	2291	5.4%
n	2291	5.4%
t	2291	5.4%
r	2291	5.4%
y	2291	5.4%
Other values (7)	11349	26.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24380	57.1%
Lowercase Letter	11455	26.8%
Dash Punctuation	4582	10.7%
Uppercase Letter	2291	5.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	4851	19.9%
0	4752	19.5%
2	3428	14.1%
8	2099	8.6%
7	2051	8.4%
6	1948	8.0%
9	1762	7.2%
4	1195	4.9%
3	1149	4.7%
5	1145	4.7%

Lowercase Letter

Value	Count	Frequency (%)
e	2291	20.0%
n	2291	20.0%
t	2291	20.0%
r	2291	20.0%
y	2291	20.0%

Uppercase Letter

Value	Count	Frequency (%)
S	2291	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4582	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	28962	67.8%
Latin	13746	32.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	4851	16.7%
0	4752	16.4%
-	4582	15.8%
2	3428	11.8%
8	2099	7.2%
7	2051	7.1%
6	1948	6.7%
9	1762	6.1%
4	1195	4.1%
3	1149	4.0%

Latin

Value	Count	Frequency (%)
S	2291	16.7%
e	2291	16.7%
n	2291	16.7%
t	2291	16.7%
r	2291	16.7%
y	2291	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42708	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	4851	11.4%
0	4752	11.1%
-	4582	10.7%
2	3428	8.0%
S	2291	5.4%
e	2291	5.4%
n	2291	5.4%
t	2291	5.4%
r	2291	5.4%
y	2291	5.4%
Other values (7)	11349	26.6%

Meropenem
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.659100829

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	2
median	3
Q3	11
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	4.262395627
Coefficient of variation (CV)	0.7531930877
Kurtosis	-1.53130696
Mean	5.659100829
Median Absolute Deviation (MAD)	1
Skewness	0.5178590168
Sum	12965
Variance	18.16801648
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2	900	39.3%
12	454	19.8%
3	294	12.8%
11	135	5.9%
10	118	5.2%
1	78	3.4%
9	75	3.3%
4	73	3.2%
7	56	2.4%
8	55	2.4%
Other values (2)	53	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	78	3.4%
2	900	39.3%
3	294	12.8%
4	73	3.2%
5	25	1.1%
6	28	1.2%
7	56	2.4%
8	55	2.4%
9	75	3.3%
10	118	5.2%

Value	Count	Frequency (%)
12	454	19.8%
11	135	5.9%
10	118	5.2%
9	75	3.3%
8	55	2.4%
7	56	2.4%
6	28	1.2%
5	25	1.1%
4	73	3.2%
3	294	12.8%

Piperacillin-tazobactam
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.9349629

Minimum	0
Maximum	14
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	0
5-th percentile	8
Q1	10
median	13
Q3	14
95-th percentile	14
Maximum	14
Range	14
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.045904362
Coefficient of variation (CV)	0.1714210911
Kurtosis	-0.5152076478
Mean	11.9349629
Median Absolute Deviation (MAD)	1
Skewness	-0.6642081827
Sum	27343
Variance	4.18572466
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
14	742	32.4%
13	481	21.0%
10	283	12.4%
11	232	10.1%
9	226	9.9%
12	174	7.6%
8	139	6.1%
7	8	0.3%
6	5	0.2%
0	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
6	5	0.2%
7	8	0.3%
8	139	6.1%
9	226	9.9%
10	283	12.4%
11	232	10.1%
12	174	7.6%
13	481	21.0%
14	742	32.4%

Value	Count	Frequency (%)
14	742	32.4%
13	481	21.0%
12	174	7.6%
11	232	10.1%
10	283	12.4%
9	226	9.9%
8	139	6.1%
7	8	0.3%
6	5	0.2%
0	1	< 0.1%

Aztreonam
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.33347883

Minimum	2
Maximum	11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	2
5-th percentile	5
Q1	11
median	11
Q3	11
95-th percentile	11
Maximum	11
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.911722305
Coefficient of variation (CV)	0.1850027795
Kurtosis	7.920233407
Mean	10.33347883
Median Absolute Deviation (MAD)	0
Skewness	-2.983663753
Sum	23674
Variance	3.654682172
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
11	1974	86.2%
5	52	2.3%
8	39	1.7%
9	39	1.7%
10	37	1.6%
3	34	1.5%
7	33	1.4%
6	29	1.3%
2	28	1.2%
4	26	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	28	1.2%
3	34	1.5%
4	26	1.1%
5	52	2.3%
6	29	1.3%
7	33	1.4%
8	39	1.7%
9	39	1.7%
10	37	1.6%
11	1974	86.2%

Value	Count	Frequency (%)
11	1974	86.2%
10	37	1.6%
9	39	1.7%
8	39	1.7%
7	33	1.4%
6	29	1.3%
5	52	2.3%
4	26	1.1%
3	34	1.5%
2	28	1.2%

Ceftriaxone
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.577477084

Minimum	3
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	3
5-th percentile	6
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	10
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.437033246
Coefficient of variation (CV)	0.1500429845
Kurtosis	11.79385528
Mean	9.577477084
Median Absolute Deviation (MAD)	0
Skewness	-3.573135714
Sum	21942
Variance	2.065064549
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
10	2060	89.9%
3	52	2.3%
8	37	1.6%
9	33	1.4%
5	32	1.4%
4	29	1.3%
7	29	1.3%
6	19	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	52	2.3%
4	29	1.3%
5	32	1.4%
6	19	0.8%
7	29	1.3%
8	37	1.6%
9	33	1.4%
10	2060	89.9%

Value	Count	Frequency (%)
10	2060	89.9%
9	33	1.4%
8	37	1.6%
7	29	1.3%
6	19	0.8%
5	32	1.4%
4	29	1.3%
3	52	2.3%

Ceftaroline
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	11
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.16542994

Minimum	2
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	2
5-th percentile	8
Q1	11
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.618709127
Coefficient of variation (CV)	0.1449750824
Kurtosis	11.52951142
Mean	11.16542994
Median Absolute Deviation (MAD)	0
Skewness	-3.271269091
Sum	25580
Variance	2.620219236
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
12	1288	56.2%
11	756	33.0%
10	57	2.5%
9	47	2.1%
8	38	1.7%
4	25	1.1%
3	23	1.0%
6	21	0.9%
7	21	0.9%
5	13	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	2	0.1%
3	23	1.0%
4	25	1.1%
5	13	0.6%
6	21	0.9%
7	21	0.9%
8	38	1.7%
9	47	2.1%
10	57	2.5%
11	756	33.0%

Value	Count	Frequency (%)
12	1288	56.2%
11	756	33.0%
10	57	2.5%
9	47	2.1%
8	38	1.7%
7	21	0.9%
6	21	0.9%
5	13	0.6%
4	25	1.1%
3	23	1.0%

Cefepime
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	15
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.14229594

Minimum	0
Maximum	15
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	11
median	11
Q3	12
95-th percentile	15
Maximum	15
Range	15
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.625339364
Coefficient of variation (CV)	0.2356192457
Kurtosis	1.271686137
Mean	11.14229594
Median Absolute Deviation (MAD)	0
Skewness	-0.7818242383
Sum	25527
Variance	6.892406779
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
11	1251	54.6%
15	379	16.5%
13	92	4.0%
4	89	3.9%
10	79	3.4%
12	79	3.4%
14	69	3.0%
9	62	2.7%
8	60	2.6%
7	58	2.5%
Other values (5)	73	3.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
2	1	< 0.1%
3	8	0.3%
4	89	3.9%
5	23	1.0%
6	40	1.7%
7	58	2.5%
8	60	2.6%
9	62	2.7%
10	79	3.4%

Value	Count	Frequency (%)
15	379	16.5%
14	69	3.0%
13	92	4.0%
12	79	3.4%
11	1251	54.6%
10	79	3.4%
9	62	2.7%
8	60	2.6%
7	58	2.5%
6	40	1.7%

Ampicillin-sulbactam
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	132.1 KiB

13	1202
12	901
11	113
10	53
9	22

Length

Max length	2
Median length	2
Mean length	1.990397206
Min length	1

Characters and Unicode

Total characters	4560
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10
2nd row	10
3rd row	12
4th row	12
5th row	12

Common Values

Value	Count	Frequency (%)
13	1202	52.5%
12	901	39.3%
11	113	4.9%
10	53	2.3%
9	22	1.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
13	1202	52.5%
12	901	39.3%
11	113	4.9%
10	53	2.3%
9	22	1.0%

Most occurring characters

Value	Count	Frequency (%)
1	2382	52.2%
3	1202	26.4%
2	901	19.8%
0	53	1.2%
9	22	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4560	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2382	52.2%
3	1202	26.4%
2	901	19.8%
0	53	1.2%
9	22	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	4560	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	2382	52.2%
3	1202	26.4%
2	901	19.8%
0	53	1.2%
9	22	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4560	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	2382	52.2%
3	1202	26.4%
2	901	19.8%
0	53	1.2%
9	22	0.5%

Ceftazidime-avibactam
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.854648625

Minimum	0
Maximum	12
Zeros	2
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	4
median	6
Q3	7
95-th percentile	12
Maximum	12
Range	12
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.206243423
Coefficient of variation (CV)	0.3768361799
Kurtosis	1.645016745
Mean	5.854648625
Median Absolute Deviation (MAD)	1
Skewness	1.052905226
Sum	13413
Variance	4.86751004
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
4	490	21.4%
5	485	21.2%
6	431	18.8%
7	371	16.2%
8	170	7.4%
12	144	6.3%
3	106	4.6%
9	40	1.7%
1	33	1.4%
2	18	0.8%
Other values (2)	3	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.1%
1	33	1.4%
2	18	0.8%
3	106	4.6%
4	490	21.4%
5	485	21.2%
6	431	18.8%
7	371	16.2%
8	170	7.4%
9	40	1.7%

Value	Count	Frequency (%)
12	144	6.3%
10	1	< 0.1%
9	40	1.7%
8	170	7.4%
7	371	16.2%
6	431	18.8%
5	485	21.2%
4	490	21.4%
3	106	4.6%
2	18	0.8%

Ceftobiprole
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	12
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.577040594

Minimum	0
Maximum	11
Zeros	173
Zeros (%)	7.6%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	11
median	11
Q3	11
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.40953917
Coefficient of variation (CV)	0.3560117697
Kurtosis	2.823983894
Mean	9.577040594
Median Absolute Deviation (MAD)	0
Skewness	-2.137213192
Sum	21941
Variance	11.62495735
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
11	1912	83.5%
0	173	7.6%
2	67	2.9%
3	43	1.9%
8	24	1.0%
7	20	0.9%
4	19	0.8%
6	9	0.4%
10	8	0.3%
9	8	0.3%
Other values (2)	8	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	173	7.6%
1	2	0.1%
2	67	2.9%
3	43	1.9%
4	19	0.8%
5	6	0.3%
6	9	0.4%
7	20	0.9%
8	24	1.0%
9	8	0.3%

Value	Count	Frequency (%)
11	1912	83.5%
10	8	0.3%
9	8	0.3%
8	24	1.0%
7	20	0.9%
6	9	0.4%
5	6	0.3%
4	19	0.8%
3	43	1.9%
2	67	2.9%

Imipenem
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.353120908

Minimum	4
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	4
5-th percentile	4
Q1	4
median	5
Q3	10
95-th percentile	10
Maximum	10
Range	6
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	2.629636698
Coefficient of variation (CV)	0.413912585
Kurtosis	-1.599932348
Mean	6.353120908
Median Absolute Deviation (MAD)	1
Skewness	0.474771394
Sum	14555
Variance	6.914989164
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	1036	45.2%
10	647	28.2%
5	249	10.9%
9	119	5.2%
6	115	5.0%
7	65	2.8%
8	60	2.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	1036	45.2%
5	249	10.9%
6	115	5.0%
7	65	2.8%
8	60	2.6%
9	119	5.2%
10	647	28.2%

Value	Count	Frequency (%)
10	647	28.2%
9	119	5.2%
8	60	2.6%
7	65	2.8%
6	115	5.0%
5	249	10.9%
4	1036	45.2%

Ceftolozane-tazobactam
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	11
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.218245308

Minimum	0
Maximum	12
Zeros	174
Zeros (%)	7.6%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	8
Q3	12
95-th percentile	12
Maximum	12
Range	12
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.585808841
Coefficient of variation (CV)	0.4363229262
Kurtosis	-0.3197667993
Mean	8.218245308
Median Absolute Deviation (MAD)	3
Skewness	-0.6264240849
Sum	18828
Variance	12.85802504
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
12	813	35.5%
6	328	14.3%
7	267	11.7%
5	234	10.2%
8	183	8.0%
0	174	7.6%
9	117	5.1%
11	70	3.1%
10	60	2.6%
4	43	1.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	174	7.6%
3	2	0.1%
4	43	1.9%
5	234	10.2%
6	328	14.3%
7	267	11.7%
8	183	8.0%
9	117	5.1%
10	60	2.6%
11	70	3.1%

Value	Count	Frequency (%)
12	813	35.5%
11	70	3.1%
10	60	2.6%
9	117	5.1%
8	183	8.0%
7	267	11.7%
6	328	14.3%
5	234	10.2%
4	43	1.9%
3	2	0.1%

Doripenem
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.678306416

Minimum	3
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	3
5-th percentile	3
Q1	3
median	4
Q3	10
95-th percentile	10
Maximum	10
Range	7
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.129372876
Coefficient of variation (CV)	0.5511102513
Kurtosis	-1.634471497
Mean	5.678306416
Median Absolute Deviation (MAD)	1
Skewness	0.4865540223
Sum	13009
Variance	9.792974598
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
3	1141	49.8%
10	643	28.1%
4	184	8.0%
9	108	4.7%
8	75	3.3%
7	53	2.3%
5	45	2.0%
6	42	1.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1141	49.8%
4	184	8.0%
5	45	2.0%
6	42	1.8%
7	53	2.3%
8	75	3.3%
9	108	4.7%
10	643	28.1%

Value	Count	Frequency (%)
10	643	28.1%
9	108	4.7%
8	75	3.3%
7	53	2.3%
6	42	1.8%
5	45	2.0%
4	184	8.0%
3	1141	49.8%

Ceftazidime
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.19947621

Minimum	3
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	3
5-th percentile	6
Q1	11
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.773635077
Coefficient of variation (CV)	0.1583676811
Kurtosis	6.728214845
Mean	11.19947621
Median Absolute Deviation (MAD)	0
Skewness	-2.693767124
Sum	25658
Variance	3.145781385
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
12	1641	71.6%
11	300	13.1%
10	110	4.8%
6	51	2.2%
7	46	2.0%
9	45	2.0%
4	38	1.7%
8	31	1.4%
5	23	1.0%
3	6	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	6	0.3%
4	38	1.7%
5	23	1.0%
6	51	2.2%
7	46	2.0%
8	31	1.4%
9	45	2.0%
10	110	4.8%
11	300	13.1%
12	1641	71.6%

Value	Count	Frequency (%)
12	1641	71.6%
11	300	13.1%
10	110	4.8%
9	45	2.0%
8	31	1.4%
7	46	2.0%
6	51	2.2%
5	23	1.0%
4	38	1.7%
3	6	0.3%

MeroRPX7009_fixed8
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	13
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.889567874

Minimum	0
Maximum	12
Zeros	176
Zeros (%)	7.7%
Negative	0
Negative (%)	0.0%
Memory size	18.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	2
Q3	6
95-th percentile	12
Maximum	12
Range	12
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.585820003
Coefficient of variation (CV)	0.9219070394
Kurtosis	0.2089114259
Mean	3.889567874
Median Absolute Deviation (MAD)	0
Skewness	1.238544066
Sum	8911
Variance	12.8581051
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
2	1170	51.1%
12	214	9.3%
0	176	7.7%
1	140	6.1%
6	113	4.9%
7	113	4.9%
3	89	3.9%
8	64	2.8%
5	62	2.7%
11	51	2.2%
Other values (3)	99	4.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	176	7.7%
1	140	6.1%
2	1170	51.1%
3	89	3.9%
4	34	1.5%
5	62	2.7%
6	113	4.9%
7	113	4.9%
8	64	2.8%
9	42	1.8%

Value	Count	Frequency (%)
12	214	9.3%
11	51	2.2%
10	23	1.0%
9	42	1.8%
8	64	2.8%
7	113	4.9%
6	113	4.9%
5	62	2.7%
4	34	1.5%
3	89	3.9%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Name	Meropenem	Piperacillin-tazobactam	Aztreonam	Ceftriaxone	Ceftaroline	Cefepime	Ampicillin-sulbactam	Ceftazidime-avibactam	Ceftobiprole	Imipenem	Ceftolozane-tazobactam	Doripenem	Ceftazidime	MeroRPX7009_fixed8
0	Sentry-2016-933582	2	8	3	3	3	4	10	4	3	4	5	3	4	2
1	Sentry-2016-934664	2	8	3	3	3	4	10	4	2	4	4	3	4	2
2	Sentry-2016-934829	12	13	11	10	12	11	12	6	11	10	12	10	12	2
3	Sentry-2016-934925	12	13	11	10	12	11	12	8	11	10	12	10	12	3
4	Sentry-2016-934954	5	13	11	10	12	11	12	4	11	4	10	5	12	3
5	Sentry-2016-935482	1	8	2	3	4	4	9	4	3	4	5	3	4	2
6	Sentry-2016-935518	11	13	11	10	12	11	12	12	11	9	12	10	12	11
7	Sentry-2016-935521	10	13	11	10	12	11	12	12	11	10	12	10	12	11
8	Sentry-2016-935572	2	10	11	10	12	11	12	5	11	4	7	3	12	2
9	Sentry-2016-935656	2	10	3	4	6	4	12	5	3	4	5	3	5	2

Last rows

	Name	Meropenem	Piperacillin-tazobactam	Aztreonam	Ceftriaxone	Ceftaroline	Cefepime	Ampicillin-sulbactam	Ceftazidime-avibactam	Ceftobiprole	Imipenem	Ceftolozane-tazobactam	Doripenem	Ceftazidime	MeroRPX7009_fixed8
2281	Sentry-2018-1087695	2	10	11	10	11	11	13	4	11	5	6	3	11	2
2282	Sentry-2018-1087702	4	9	11	10	11	10	12	5	11	4	6	3	11	2
2283	Sentry-2018-1087723	3	11	11	10	11	14	13	6	11	4	8	3	12	2
2284	Sentry-2018-1087757	2	10	11	10	11	11	12	4	11	4	5	3	11	2
2285	Sentry-2018-1087767	2	10	11	10	11	13	13	4	11	4	5	3	11	2
2286	Sentry-2018-1087789	2	12	11	10	11	15	13	5	11	4	8	3	12	2
2287	Sentry-2018-1087802	2	10	11	10	11	11	12	4	11	4	6	3	11	2
2288	Sentry-2018-1087803	2	12	11	10	11	13	13	3	11	4	7	3	12	1
2289	Sentry-2018-1087824	2	10	11	10	11	12	13	4	11	4	5	3	12	2
2290	Sentry-2018-1087829	2	11	11	10	11	12	12	4	11	4	6	3	11	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows